Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	10742
Missing cells	23391
Missing cells (%)	16.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 MiB
Average record size in memory	104.0 B

Variable types

Categorical	1
Numeric	11
Unsupported	1

Alerts

`time` has a high cardinality: 283 distinct values	High cardinality
`SDDY` is highly correlated with `GZDY` and 1 other fields	High correlation
`GZDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`BD` is highly correlated with `ZZ`	High correlation
`ZZ` is highly correlated with `BD`	High correlation
`SDDY` is highly correlated with `GZDY` and 2 other fields	High correlation
`GZDY` is highly correlated with `SDDY` and 2 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 2 other fields	High correlation
`XLCS` is highly correlated with `SDDY` and 2 other fields	High correlation
`SDDY` is highly correlated with `GZDY` and 1 other fields	High correlation
`GZDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`PJDY` is highly correlated with `SDDY` and 1 other fields	High correlation
`CLL` is highly correlated with `DJWD` and 2 other fields	High correlation
`SDDY` is highly correlated with `GZDY` and 3 other fields	High correlation
`DJWD` is highly correlated with `CLL` and 3 other fields	High correlation
`FZB` is highly correlated with `DJWD`	High correlation
`GZDY` is highly correlated with `CLL` and 5 other fields	High correlation
`PJDY` is highly correlated with `CLL` and 5 other fields	High correlation
`XLCS` is highly correlated with `SDDY` and 3 other fields	High correlation
`BD` is highly correlated with `GZDY` and 3 other fields	High correlation
`ZZ` is highly correlated with `BD`	High correlation
`number` is highly correlated with `SDDY`	High correlation
`CLL` has 339 (3.2%) missing values	Missing
`SDDY` has 826 (7.7%) missing values	Missing
`LSP` has 3503 (32.6%) missing values	Missing
`YHLND` has 10742 (100.0%) missing values	Missing
`DJWD` has 3502 (32.6%) missing values	Missing
`FZB` has 349 (3.2%) missing values	Missing
`GZDY` has 826 (7.7%) missing values	Missing
`PJDY` has 826 (7.7%) missing values	Missing
`XLCS` has 826 (7.7%) missing values	Missing
`BD` has 826 (7.7%) missing values	Missing
`ZZ` has 826 (7.7%) missing values	Missing
`time` is uniformly distributed	Uniform
`YHLND` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2022-07-06 12:44:28.620362
Analysis finished	2022-07-06 12:45:00.951372
Duration	32.33 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	283
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Memory size	84.0 KiB

2021-08-01 00:00:00	38
2022-02-09 00:00:00	38
2022-01-26 00:00:00	38
2022-01-27 00:00:00	38
2022-01-28 00:00:00	38
Other values (278)	10552

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2021-08-01 00:00:00
2nd row	2021-08-02 00:00:00
3rd row	2021-08-03 00:00:00
4th row	2021-08-04 00:00:00
5th row	2021-08-05 00:00:00

Common Values

Value	Count	Frequency (%)
2021-08-01 00:00:00	38	0.4%
2022-02-09 00:00:00	38	0.4%
2022-01-26 00:00:00	38	0.4%
2022-01-27 00:00:00	38	0.4%
2022-01-28 00:00:00	38	0.4%
2022-01-29 00:00:00	38	0.4%
2022-01-30 00:00:00	38	0.4%
2022-01-31 00:00:00	38	0.4%
2022-02-01 00:00:00	38	0.4%
2022-02-02 00:00:00	38	0.4%
Other values (273)	10362	96.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
00:00:00	10742	50.0%
2021-08-01	38	0.2%
2021-08-10	38	0.2%
2021-08-16	38	0.2%
2021-08-15	38	0.2%
2021-08-14	38	0.2%
2021-08-13	38	0.2%
2021-08-12	38	0.2%
2021-08-11	38	0.2%
2021-08-09	38	0.2%
Other values (274)	10400	48.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

CLL
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	37
Distinct (%)	0.4%
Missing	339
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%
Mean	99.83278766

Minimum	99.34
Maximum	99.87
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	99.34
5-th percentile	99.79
Q1	99.82
median	99.84
Q3	99.85
95-th percentile	99.86
Maximum	99.87
Range	0.53
Interquartile range (IQR)	0.03

Descriptive statistics

Standard deviation	0.03288966765
Coefficient of variation (CV)	0.0003294475534
Kurtosis	35.51343228
Mean	99.83278766
Median Absolute Deviation (MAD)	0.01
Skewness	-4.725033174
Sum	1038560.49
Variance	0.001081730238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
99.85	4100	38.2%
99.84	1828	17.0%
99.83	1175	10.9%
99.82	1072	10.0%
99.86	650	6.1%
99.8	466	4.3%
99.81	429	4.0%
99.78	245	2.3%
99.79	161	1.5%
99.77	59	0.5%
Other values (27)	218	2.0%
(Missing)	339	3.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
99.34	1	< 0.1%
99.4	1	< 0.1%
99.42	1	< 0.1%
99.45	1	< 0.1%
99.46	1	< 0.1%
99.47	1	< 0.1%
99.48	3	< 0.1%
99.49	2	< 0.1%
99.52	1	< 0.1%
99.54	1	< 0.1%

Value	Count	Frequency (%)
99.87	16	0.1%
99.86	650	6.1%
99.85	4100	38.2%
99.84	1828	17.0%
99.83	1175	10.9%
99.82	1072	10.0%
99.81	429	4.0%
99.8	466	4.3%
99.79	161	1.5%
99.78	245	2.3%

SDDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	68
Distinct (%)	0.7%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	3969.681021

Minimum	0
Maximum	4500
Zeros	28
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3900
Q1	3950
median	3980
Q3	4005
95-th percentile	4065
Maximum	4500
Range	4500
Interquartile range (IQR)	55

Descriptive statistics

Standard deviation	216.6721267
Coefficient of variation (CV)	0.0545817474
Kurtosis	315.4257784
Mean	3969.681021
Median Absolute Deviation (MAD)	30
Skewness	-17.34456007
Sum	39363357
Variance	46946.8105
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3980	1574	14.7%
4000	759	7.1%
3950	667	6.2%
3990	622	5.8%
4020	562	5.2%
4010	339	3.2%
3960	307	2.9%
3940	297	2.8%
3970	285	2.7%
3975	272	2.5%
Other values (58)	4232	39.4%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	28	0.3%
3865	54	0.5%
3870	54	0.5%
3875	18	0.2%
3880	63	0.6%
3885	79	0.7%
3890	83	0.8%
3895	95	0.9%
3900	178	1.7%
3905	5	< 0.1%

Value	Count	Frequency (%)
4500	10	0.1%
4400	4	< 0.1%
4350	2	< 0.1%
4300	1	< 0.1%
4250	2	< 0.1%
4200	3	< 0.1%
4195	1	< 0.1%
4175	1	< 0.1%
4170	1	< 0.1%
4165	1	< 0.1%

LSP
Real number (ℝ_≥0)

MISSING

Distinct	8
Distinct (%)	0.1%
Missing	3503
Missing (%)	32.6%
Infinite	0
Infinite (%)	0.0%
Mean	17.8050145

Minimum	16
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	16
5-th percentile	16
Q1	17
median	18
Q3	19
95-th percentile	20
Maximum	20
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.34963014
Coefficient of variation (CV)	0.07580056394
Kurtosis	-1.098567911
Mean	17.8050145
Median Absolute Deviation (MAD)	1
Skewness	0.202284765
Sum	128890.5
Variance	1.821501516
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
18	1881	17.5%
16	1578	14.7%
17	1567	14.6%
20	1121	10.4%
19	1079	10.0%
16.5	7	0.1%
18.5	4	< 0.1%
17.5	2	< 0.1%
(Missing)	3503	32.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
16	1578	14.7%
16.5	7	0.1%
17	1567	14.6%
17.5	2	< 0.1%
18	1881	17.5%
18.5	4	< 0.1%
19	1079	10.0%
20	1121	10.4%

Value	Count	Frequency (%)
20	1121	10.4%
19	1079	10.0%
18.5	4	< 0.1%
18	1881	17.5%
17.5	2	< 0.1%
17	1567	14.6%
16.5	7	0.1%
16	1578	14.7%

YHLND
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	10742
Missing (%)	100.0%
Memory size	84.0 KiB

DJWD
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	24
Distinct (%)	0.3%
Missing	3502
Missing (%)	32.6%
Infinite	0
Infinite (%)	0.0%
Mean	24.84657459

Minimum	14.5
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	14.5
5-th percentile	22
Q1	24
median	26
Q3	26
95-th percentile	26
Maximum	26
Range	11.5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.676662457
Coefficient of variation (CV)	0.06748062802
Kurtosis	6.465236126
Mean	24.84657459
Median Absolute Deviation (MAD)	0
Skewness	-2.220096658
Sum	179889.2
Variance	2.811196995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
26	3679	34.2%
25	988	9.2%
24	944	8.8%
23	524	4.9%
24.5	226	2.1%
23.5	199	1.9%
25.5	138	1.3%
22	109	1.0%
22.5	93	0.9%
21.5	71	0.7%
Other values (14)	269	2.5%
(Missing)	3502	32.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14.5	2	< 0.1%
15.5	3	< 0.1%
16	10	0.1%
16.5	17	0.2%
17	17	0.2%
17.5	25	0.2%
18	27	0.3%
18.5	29	0.3%
19	23	0.2%
19.5	20	0.2%

Value	Count	Frequency (%)
26	3679	34.2%
25.5	138	1.3%
25	988	9.2%
24.5	226	2.1%
24	944	8.8%
23.5	199	1.9%
23.4	3	< 0.1%
23	524	4.9%
22.5	93	0.9%
22	109	1.0%

FZB
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	68
Distinct (%)	0.7%
Missing	349
Missing (%)	3.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.649146541

Minimum	2.39
Maximum	3.37
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	2.39
5-th percentile	2.51
Q1	2.58
median	2.62
Q3	2.69
95-th percentile	2.88
Maximum	3.37
Range	0.98
Interquartile range (IQR)	0.11

Descriptive statistics

Standard deviation	0.114738687
Coefficient of variation (CV)	0.04331156667
Kurtosis	4.406459292
Mean	2.649146541
Median Absolute Deviation (MAD)	0.05
Skewness	1.572253098
Sum	27532.58
Variance	0.0131649663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.61	636	5.9%
2.6	572	5.3%
2.58	570	5.3%
2.59	559	5.2%
2.62	523	4.9%
2.57	487	4.5%
2.63	483	4.5%
2.56	453	4.2%
2.64	418	3.9%
2.65	359	3.3%
Other values (58)	5333	49.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.39	5	< 0.1%
2.42	18	0.2%
2.43	7	0.1%
2.44	7	0.1%
2.45	35	0.3%
2.46	14	0.1%
2.47	61	0.6%
2.48	63	0.6%
2.49	71	0.7%
2.5	90	0.8%

Value	Count	Frequency (%)
3.37	7	0.1%
3.33	7	0.1%
3.26	14	0.1%
3.23	7	0.1%
3.22	7	0.1%
3.2	9	0.1%
3.17	7	0.1%
3.12	7	0.1%
3.11	7	0.1%
3.07	18	0.2%

GZDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	59
Distinct (%)	0.6%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	3.992251916

Minimum	0
Maximum	6.26
Zeros	26
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3.92
Q1	3.97
median	4
Q3	4.04
95-th percentile	4.09
Maximum	6.26
Range	6.26
Interquartile range (IQR)	0.07

Descriptive statistics

Standard deviation	0.2189647892
Coefficient of variation (CV)	0.05484743793
Kurtosis	293.3498062
Mean	3.992251916
Median Absolute Deviation (MAD)	0.03
Skewness	-15.97429832
Sum	39587.17
Variance	0.04794557889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.99	854	8.0%
3.98	790	7.4%
4	777	7.2%
4.01	758	7.1%
3.97	692	6.4%
4.03	649	6.0%
4.02	614	5.7%
4.04	571	5.3%
3.96	569	5.3%
3.95	481	4.5%
Other values (49)	3161	29.4%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26	0.2%
1.31	1	< 0.1%
1.94	1	< 0.1%
2.16	1	< 0.1%
2.63	1	< 0.1%
2.66	1	< 0.1%
3.49	1	< 0.1%
3.85	3	< 0.1%
3.87	5	< 0.1%
3.88	10	0.1%

Value	Count	Frequency (%)
6.26	1	< 0.1%
6.07	1	< 0.1%
5.72	1	< 0.1%
5.3	1	< 0.1%
4.95	1	< 0.1%
4.58	2	< 0.1%
4.5	1	< 0.1%
4.45	1	< 0.1%
4.41	1	< 0.1%
4.39	1	< 0.1%

PJDY
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	66
Distinct (%)	0.7%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	4.007325534

Minimum	0
Maximum	6.31
Zeros	26
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3.93
Q1	3.98
median	4.01
Q3	4.05
95-th percentile	4.12
Maximum	6.31
Range	6.31
Interquartile range (IQR)	0.07

Descriptive statistics

Standard deviation	0.2221287631
Coefficient of variation (CV)	0.05543067595
Kurtosis	281.3756921
Mean	4.007325534
Median Absolute Deviation (MAD)	0.04
Skewness	-15.3303297
Sum	39736.64
Variance	0.04934118741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.99	769	7.2%
4	749	7.0%
4.01	732	6.8%
3.98	676	6.3%
4.02	630	5.9%
4.03	612	5.7%
3.97	560	5.2%
4.04	547	5.1%
3.96	492	4.6%
4.05	445	4.1%
Other values (56)	3704	34.5%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	26	0.2%
1.31	1	< 0.1%
2.16	1	< 0.1%
2.63	1	< 0.1%
2.64	1	< 0.1%
2.66	1	< 0.1%
3.66	1	< 0.1%
3.85	1	< 0.1%
3.87	3	< 0.1%
3.88	8	0.1%

Value	Count	Frequency (%)
6.31	1	< 0.1%
6.22	1	< 0.1%
6.11	1	< 0.1%
5.59	1	< 0.1%
5	1	< 0.1%
4.78	1	< 0.1%
4.72	1	< 0.1%
4.66	1	< 0.1%
4.55	1	< 0.1%
4.52	1	< 0.1%

XLCS
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	403
Distinct (%)	4.1%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	926.9453409

Minimum	0
Maximum	1140
Zeros	30
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	827
Q1	888
median	927
Q3	973
95-th percentile	1037
Maximum	1140
Range	1140
Interquartile range (IQR)	85

Descriptive statistics

Standard deviation	84.32650229
Coefficient of variation (CV)	0.09097246469
Kurtosis	48.95670128
Mean	926.9453409
Median Absolute Deviation (MAD)	43
Skewness	-4.63293214
Sum	9191590
Variance	7110.958989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
914	85	0.8%
920	79	0.7%
919	77	0.7%
932	77	0.7%
899	73	0.7%
911	73	0.7%
889	72	0.7%
902	72	0.7%
922	72	0.7%
912	72	0.7%
Other values (393)	9164	85.3%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	30	0.3%
1	1	< 0.1%
9	1	< 0.1%
20	1	< 0.1%
92	1	< 0.1%
211	1	< 0.1%
259	1	< 0.1%
289	1	< 0.1%
369	1	< 0.1%
448	1	< 0.1%

Value	Count	Frequency (%)
1140	1	< 0.1%
1135	1	< 0.1%
1133	1	< 0.1%
1131	1	< 0.1%
1130	1	< 0.1%
1128	1	< 0.1%
1125	2	< 0.1%
1122	1	< 0.1%
1120	2	< 0.1%
1118	1	< 0.1%

BD
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	475
Distinct (%)	4.8%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.170246067

Minimum	0
Maximum	47.44
Zeros	27
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1.13
Q1	1.52
median	1.99
Q3	2.65
95-th percentile	3.77
Maximum	47.44
Range	47.44
Interquartile range (IQR)	1.13

Descriptive statistics

Standard deviation	0.9713310009
Coefficient of variation (CV)	0.4475672209
Kurtosis	477.4931407
Mean	2.170246067
Median Absolute Deviation (MAD)	0.535
Skewness	11.04576341
Sum	21520.16
Variance	0.9434839132
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.63	75	0.7%
1.57	70	0.7%
1.51	68	0.6%
1.49	67	0.6%
1.77	67	0.6%
1.41	67	0.6%
1.56	67	0.6%
1.34	66	0.6%
1.65	65	0.6%
1.3	64	0.6%
Other values (465)	9240	86.0%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	27	0.3%
0.23	1	< 0.1%
0.45	1	< 0.1%
0.56	2	< 0.1%
0.61	1	< 0.1%
0.62	1	< 0.1%
0.64	1	< 0.1%
0.66	3	< 0.1%
0.67	1	< 0.1%
0.68	2	< 0.1%

Value	Count	Frequency (%)
47.44	1	< 0.1%
11.83	1	< 0.1%
11.16	1	< 0.1%
7.92	1	< 0.1%
7.9	1	< 0.1%
7.23	1	< 0.1%
6.86	1	< 0.1%
6.49	1	< 0.1%
6.31	2	< 0.1%
6.3	1	< 0.1%

ZZ
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	1425
Distinct (%)	14.4%
Missing	826
Missing (%)	7.7%
Infinite	0
Infinite (%)	0.0%
Mean	8.595066559

Minimum	0
Maximum	198.63
Zeros	27
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	0
5-th percentile	5.46
Q1	6.42
median	7.55
Q3	9.64
95-th percentile	15.1975
Maximum	198.63
Range	198.63
Interquartile range (IQR)	3.22

Descriptive statistics

Standard deviation	3.954363477
Coefficient of variation (CV)	0.4600736305
Kurtosis	543.7707539
Mean	8.595066559
Median Absolute Deviation (MAD)	1.38
Skewness	12.87368105
Sum	85228.68
Variance	15.6369905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.25	36	0.3%
6.31	34	0.3%
7.19	34	0.3%
6.65	33	0.3%
6.24	33	0.3%
6.69	32	0.3%
6.42	32	0.3%
6.92	31	0.3%
6.16	30	0.3%
6.44	30	0.3%
Other values (1415)	9591	89.3%
(Missing)	826	7.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	27	0.3%
0.27	1	< 0.1%
0.51	1	< 0.1%
0.75	1	< 0.1%
0.87	1	< 0.1%
0.91	1	< 0.1%
1.03	1	< 0.1%
1.06	1	< 0.1%
1.13	1	< 0.1%
2.79	1	< 0.1%

Value	Count	Frequency (%)
198.63	1	< 0.1%
46.32	1	< 0.1%
45.88	1	< 0.1%
43.78	1	< 0.1%
43.36	1	< 0.1%
39.61	1	< 0.1%
37.35	1	< 0.1%
33.55	1	< 0.1%
31.7	1	< 0.1%
31.18	1	< 0.1%

number
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	38
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3057.497207

Minimum	3039
Maximum	3076
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	84.0 KiB

Quantile statistics

Minimum	3039
5-th percentile	3040
Q1	3048
median	3057
Q3	3067
95-th percentile	3075
Maximum	3076
Range	37
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	10.97217162
Coefficient of variation (CV)	0.003588612148
Kurtosis	-1.203465514
Mean	3057.497207
Median Absolute Deviation (MAD)	10
Skewness	0.0007505223767
Sum	32843635
Variance	120.3885501
Monotonicity	Increasing

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
3039	283	2.6%
3040	283	2.6%
3061	283	2.6%
3062	283	2.6%
3063	283	2.6%
3064	283	2.6%
3065	283	2.6%
3066	283	2.6%
3067	283	2.6%
3068	283	2.6%
Other values (28)	7912	73.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3039	283	2.6%
3040	283	2.6%
3041	283	2.6%
3042	283	2.6%
3043	283	2.6%
3044	283	2.6%
3045	283	2.6%
3046	283	2.6%
3047	283	2.6%
3048	283	2.6%

Value	Count	Frequency (%)
3076	283	2.6%
3075	283	2.6%
3074	283	2.6%
3073	283	2.6%
3072	283	2.6%
3071	283	2.6%
3070	283	2.6%
3069	283	2.6%
3068	283	2.6%
3067	283	2.6%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	time	CLL	SDDY	LSP	YHLND	DJWD	FZB	GZDY	PJDY	XLCS	BD	ZZ	number
0	2021-08-01 00:00:00	99.81	3890.0	NaN	NaN	NaN	2.62	3.91	3.96	889.0	3.29	19.29	3039
1	2021-08-02 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.62	3.91	3.94	891.0	2.83	15.70	3039
2	2021-08-03 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.94	4.00	847.0	2.96	12.50	3039
3	2021-08-04 00:00:00	99.86	3890.0	NaN	NaN	NaN	2.60	3.94	3.99	875.0	2.41	10.05	3039
4	2021-08-05 00:00:00	99.86	3890.0	NaN	NaN	NaN	2.60	3.92	3.93	867.0	3.71	14.95	3039
5	2021-08-06 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.93	3.94	853.0	2.69	20.29	3039
6	2021-08-07 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.93	4.00	864.0	2.54	21.77	3039
7	2021-08-08 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.94	3.94	828.0	3.02	20.59	3039
8	2021-08-09 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.92	3.92	829.0	3.23	12.79	3039
9	2021-08-10 00:00:00	99.82	3890.0	NaN	NaN	NaN	2.60	3.93	3.93	822.0	2.87	17.33	3039

Last rows

	time	CLL	SDDY	LSP	YHLND	DJWD	FZB	GZDY	PJDY	XLCS	BD	ZZ	number
10732	2022-05-13 00:00:00	99.84	3985.0	17.0	NaN	25.0	2.64	3.99	3.99	980.0	1.56	7.66	3076
10733	2022-05-14 00:00:00	99.84	3985.0	17.0	NaN	25.0	2.64	3.97	3.97	965.0	1.94	8.67	3076
10734	2022-05-15 00:00:00	99.84	3985.0	16.0	NaN	25.0	2.64	3.99	4.00	991.0	2.19	8.99	3076
10735	2022-05-16 00:00:00	99.84	3985.0	16.0	NaN	26.0	2.64	4.00	4.00	997.0	2.49	6.86	3076
10736	2022-05-17 00:00:00	99.84	3985.0	19.0	NaN	25.0	2.64	3.99	3.99	917.0	1.52	6.84	3076
10737	2022-05-18 00:00:00	99.84	3985.0	18.0	NaN	26.0	2.64	3.98	3.98	924.0	1.53	6.46	3076
10738	2022-05-19 00:00:00	99.84	3985.0	17.0	NaN	26.0	2.62	3.99	3.99	944.0	2.16	8.18	3076
10739	2022-05-20 00:00:00	99.84	NaN	17.0	NaN	26.0	2.62	NaN	NaN	NaN	NaN	NaN	3076
10740	2022-05-21 00:00:00	99.86	3985.0	20.0	NaN	25.5	2.62	3.97	3.97	881.0	1.37	6.78	3076
10741	2022-05-22 00:00:00	99.86	3985.0	18.0	NaN	25.5	2.62	3.97	3.97	883.0	1.57	9.76	3076

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows